UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZkA+QL4r9JuvhD+jMOfYdy4Qjy6wnJ853d9sfHxL0c='
WHERE
key_id = '34fb09219410e0d2d0011785e94a3017b336c38c3e2a507639bff0e43cd6fc02'
AND (
token = 'zZkA+QL4r9JuvhD+jMOfYdy4Qjy6wnJ853d9sfHxL0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)