UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9JYfPyggyNV4GjbhCWrKiXKnA54/8e88yYXs6/A8T8='
WHERE
key_id = '872415f72c7cbf92bbe5626b1038172164257d189c75cd190b28d77311dbbf47'
AND (
token = 'A9JYfPyggyNV4GjbhCWrKiXKnA54/8e88yYXs6/A8T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)