UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hJn7WAuBVJm6Vt3YD/qVXUggAndcHxhg60fURssam8U='
WHERE
key_id = '87bc200da69eb724cf0f94aa813f4bf1b123e17379fc9b02c86163f9e1067640'
AND (
token = 'hJn7WAuBVJm6Vt3YD/qVXUggAndcHxhg60fURssam8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)