UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5hv9wBEi02A4Cig320wnXinzXBbDA0jtzKaLqD27UzQ='
WHERE
key_id = '03b47817f0d6d9ecf095807dcc3e54a31266dd8fe9b49b919b4d2f667bdcc4a0'
AND (
token = '5hv9wBEi02A4Cig320wnXinzXBbDA0jtzKaLqD27UzQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)