UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x836UvemTd2fvxbIbBlNhGU92IGXubKVgSn9dwm+LTQ='
WHERE
key_id = '24f7ea744989fdfc6829e8e118d81361298a7349c6ef34df070fefcd04e165de'
AND (
token = 'x836UvemTd2fvxbIbBlNhGU92IGXubKVgSn9dwm+LTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)